﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="events.aspx.vb" Inherits="SingerProfile.events" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <br />
    <fieldset>
    <legend class="Event_Coming">Coming Events List</legend>
<asp:GridView ID="GridView_ComingEvents" runat="server" AllowSorting="True" 
    AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource2" 
    ForeColor="#333333" GridLines="None" Width="100%">
    <AlternatingRowStyle BackColor="White" />
    <Columns>
        <asp:BoundField DataField="event_name" HeaderText="event_name" 
            SortExpression="event_name" />
        <asp:BoundField DataField="event_location" HeaderText="event_location" 
            SortExpression="event_location" />
        <asp:BoundField DataField="event_description" HeaderText="event_description" 
            SortExpression="event_description" />
        <asp:BoundField DataField="event_postcode" HeaderText="event_postcode" 
            SortExpression="event_postcode" />
        <asp:BoundField DataField="event_date_time" HeaderText="event_date_time" 
            SortExpression="event_date_time" />
    </Columns>
    <EditRowStyle BackColor="#7C6F57" />
    <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
    <RowStyle BackColor="#E3EAEB" />
    <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
    <SortedAscendingCellStyle BackColor="#F8FAFA" />
    <SortedAscendingHeaderStyle BackColor="#246B61" />
    <SortedDescendingCellStyle BackColor="#D4DFE1" />
    <SortedDescendingHeaderStyle BackColor="#15524A" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
    ConnectionString="<%$ ConnectionStrings:SingerProfileConStr %>" 
    ProviderName="<%$ ConnectionStrings:SingerProfileConStr.ProviderName %>" 
    SelectCommand="SELECT [event_name], [event_location], [event_description], [event_postcode], [event_date_time] FROM [Qry_ComingEvents]">
</asp:SqlDataSource>
    </fieldset><br />
    <hr />
    <br />
    <fieldset>
    <legend class="Event_Coming">Finished Events List</legend>

<asp:GridView ID="GridView_finishedEvents" runat="server" AllowSorting="True" 
    AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" 
    ForeColor="#333333" GridLines="None" Width="100%">
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    <Columns>
        <asp:BoundField DataField="event_name" HeaderText="event_name" 
            SortExpression="event_name" />
        <asp:BoundField DataField="event_location" HeaderText="event_location" 
            SortExpression="event_location" />
        <asp:BoundField DataField="event_description" HeaderText="event_description" 
            SortExpression="event_description" />
        <asp:BoundField DataField="event_date_time" HeaderText="event_date_time" 
            SortExpression="event_date_time" />
        <asp:HyperLinkField DataNavigateUrlFields="event_postcode" 
            DataNavigateUrlFormatString="https://maps.google.co.uk/maps?q={0}&amp;hl=en" 
            DataTextField="event_postcode" HeaderText="Maps" />
    </Columns>
    <EditRowStyle BackColor="#999999" />
    <EmptyDataRowStyle HorizontalAlign="Justify" />
    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
    <SortedAscendingCellStyle BackColor="#E9E7E2" />
    <SortedAscendingHeaderStyle BackColor="#506C8C" />
    <SortedDescendingCellStyle BackColor="#FFFDF8" />
    <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:SingerProfileConStr %>" 
    ProviderName="<%$ ConnectionStrings:SingerProfileConStr.ProviderName %>" 
    SelectCommand="SELECT [event_name], [event_location], [event_description], [event_postcode], [event_date_time] FROM [Qry_FinishedEvents]">
</asp:SqlDataSource>

    </fieldset>
    
<br />
    <br />
    <br />
    <br />
<br />
<br />
</asp:Content>
